package com.ksp.api.lucene;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;


public interface IndexMapper {

	String QRY_TSK_TOL = "";
	
	
	String QRY_TSK_INF = ""
			+ "SELECT KSP_TCH_IDN AS TCH_IDN,"
			+ "       KSP_KSP_TTL AS KSP_TTL,"
			+ "       KSP_KSP_CON AS KSP_CON,"
			+ "       KSP_IMP_DEG AS IMP_DEG,"
			+ "       KSP_DEA_USR AS DEA_USR,"
			+ "       KSP_DEA_UNM AS DEA_UNM,"
			+ "       KSP_TSK_STS AS TSK_STS,"
			+ "       KSP_TSK_TYP AS TSK_TYP,"
			+ "       KSP_QUA_USR AS QUA_USR,"
			+ "       KSP_QUA_UNM AS QUA_UNM,"
			+ "       KSP_QUA_DBG AS QUA_DBG,"
			+ "       KSP_MNT_DAT AS MNT_DAT,"
			+ "       KSP_SPC_RMK AS SPC_RMK"
			+ "  FROM kspt.ksp_ksp_qua"
			+ " ORDER BY KSP_QUA_DBG DESC"
			+ "";
	
	@Select(QRY_TSK_TOL)
	List<Map<String, Object>> qryTskTol(Map<String, Object> pPamMap);
	
	
	@Select(QRY_TSK_INF)
	List<Map<String, Object>> qryTskInf(Map<String, Object> pPamMap);
	
}
